EMT Practice Test

1. Question Content...

---

Question1: What is XS?
Please choose the correct answer.
Response:

Question2: What data source is available for Join nodes in calculation views?
Please choose the correct answer.
Response:

Question3: You created a user-defined function with the INVOKER security option. Which user's authorizations are checked when the function is executed?
Please choose the correct answer.
Response:

Question4: What are components of SAP HANA EIM?
There are 2 correct answers to this question.
Response:

Question5: What can you discover using Data Lineage?
Please choose the correct answer.
Response:

Question6: Identify the features and benefits of a calculation view.
There are 3 correct answers to this question.
Response:

Question7: What character is prepended to a SQLScript variable when it's used as an input variable?
Please choose the correct answer.
Response:

Question8: You are building a new calculation view, A, Which includes a projection node that refers to another calculation view, B. WHY would you use the extract semantics feature?
Please choose the correct answer.
Response:

Question9: Why do you assign semantic types to measures or attributes in calculation views?
Please choose the correct answer.
Response:

Question10: What information can you find in the Plan Graph?
There are 2 correct answers to this question.
Response:

Question11: Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question.
Response:

Question12: Which of the following are reasons you should use Core Data Services (CDS) to create a schema?
There are 2 correct answers to this question.
Response:

Question13: Which interface client is used for XSA application development?
Please choose the correct answer.
Response:

Question14: Why did SAP move from XS to XSA?
There are 2 correct answers to this question.
Response:

Question15: What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement?
Please choose the correct answer.
Response:

Question16: Identify the object that adds a WHERE clause to the query.
Please choose the correct answer.
Response:

Question17: In SAP HANA Series Data processing, what is the definition of a profile?
Please choose the correct answer.
Response:

Question18: You want to see in a Union node which data sources return no results for a query. How do you achieve this?
Please choose the correct answer.
Response:

Question19: For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response:

Question20: In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?
Please choose the correct answer.
Response:

Question21: Which of the following are valid types of privileges in SAP HANA?
There are 2 correct answers to this question.
Response:

Question22: What must be installed for PAL to work?
Please choose the correct answer.
Response:

Question23: Which of the following tasks are required to get the database objects created in the HDI container?
There are 2 correct answers to this question.
Response:

Question24: In which of the following circumstances do you use graph processing?
There are 2 correct answers to this question.
Response:

Question25: Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screen shot?

Question26: You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.

Question27: What are the basic spatial shapes you can store in SAP HANA Spatial?
There are 3 correct answers to this question.
Response:

Question28: What does SAP HANA load when starting up and before indicating that it's ready?
There are 3 correct answers to this question.
Response:

Question29: What is the persistent storage layer used for?
There are 2 correct answers to this question.
Response:

Question30: You have logs from a website. How do you show the total number of website visitors that used a mobile phone?
There are 2 correct answers to this question.
Response:

Question31: Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question.
Response:

Question32: Why would you use SAP HANA Vora?
Please choose the correct answer.
Response:

Question33: While converting currencies, which parameter is as important as source and target currencies?
Please choose the correct answer.
Response:

Question34: Your calculation view presents employee names which must only be seen by managers. Which steps are required to implement this?
There are 2 correct answers to this question.
Response:

Question35: In which package in SAP HANA will you find the SAP HANA Live views?
Please choose the correct answer.
Response:

Question36: What does SQL script provide to extend standard SQL?
There are 2 correct answers to this question.
Response:

Question37: What is scale-out?
There are 2 correct answers to this question.
Response:

Question38: Which are of the following languages supported by SAP HANA Graph are optimized for graph processing?
There are 2 correct answers to this question.
Response:

Question39: Why would you create a procedure?
There are 2 correct answers to this question.
Response:

Question40: What performance technique should you implement to improve join performance?
Please choose the correct answer.
Response:

Question41: What are the vertices in a graph model?
Please choose the correct answer.
Response:

Question42: What node can you use for sorting results, for example, to show the top 100?
Please choose the correct answer.
Response:

Question43: Which hierarchies can you enable for SQL access?
Please choose the correct answer.
Response:

Question44: In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario?
There are 2 correct answers to this question
Response:

Question45: In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully?
There are 2 correct answers to this question.
Response:

Question46: You're writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous games.
How do you use the data of the player information and the scores?
Please choose the correct answer.
Response:

Question47: How should you create a procedure?
Please choose the correct answer.
Response:

Question48: Which of the following are no longer required in the architecture of SAP S/4HANA?
There are 2 correct answers to this question.
Response:

Question49: What do you create to find the number of unique items sold per shop?
Please choose the correct answer.
Response:

Question50: In which type of node can you create calculated columns?
There are 2 correct answers to this question.
Response:

Question51: What are the four SAP HANA platform services?
There are 4 correct answers to this question.
Response:

Question52: What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.
Response:

Question53: When would you use a function?
Please choose the correct answer.
Response:

Question54: The virtual data model for SAP S/4HANA is based on which of these?
Please choose the correct answer.
Response:

Question55: You create a hierarchy in a dimension calculation view. You then consume this dimension calculation view with star join in a cube calculation view. How do you allow SQL access to the hierarchy?
Response:

Question56: Which recent technology innovations have triggered the opportunity to build a next generation data processing platform?
There are 2 correct answers to this question.
Response:

Question57: When using the CONTAINS predicate, what are the restrictions you must you keep in mind?
There are 2 correct answers to this question.
Response:

Question58: Which type of cloud solution is SAP HANA Enterprise Cloud an example of?
Please choose the correct answer.
Response:

Question59: What are features of SDA?
There are 2 correct answers to this question.
Response:

Question60: What are the values for X, Y, and Z?
Please choose the correct answer.
Response:

Question61: You require faster performance for a frequently queried calculation view. You have just enabled the static Results cache for this calculation view with a cache period = 120 minutes.
What are effects of this action?
There are 3 correct answers to this question.
Response:

Question62: You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
Response:

Question63: In an XSA/HDI environment, which of the following is used for source version control of calculation views?
Please choose the correct answer.
Response:

Question64: Which type of data are used to represent spatial information?
There are 2 correct answers to this question.
Response:

Question65: You want to publish your business intelligence content directly to SAP Analytics Cloud. Which tool do you use?
Please choose the correct answer.
Response:

Question66: How many processing tiers do you usually find in a native SAP HANA application stack?
Please choose the correct answer.
Response:

Question67: What do you use in a SQL query to sort fuzzy text search results by relevance?
Please choose the correct answer.
Response:

Question68: You create a full-text index. For what text feature clause do you need to specify a configuration?
Response:

Question69: Your calculation view includes the following SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY*PRICE.
In which node do you define the calculation to display the correct aggregated result?
Please choose the correct answer.
Response:

Question70: How do you move code to SAP HANA?
There are 2 correct answers to this question.
Response:

Question71: Which type of cloud solution is Amazon Web Services (AWS) an example of?
Response:

Question72: Where is SAP HANA Live installed?
Please choose the correct answer.
Response:

Question73: Where do you use SQLScript outside of the development environment discussed in this chapter?
There are 3 correct answers to this question.
Response:

Question74: Why might you use SAP HANA Graph with text analysis?
Please choose the correct answer.
Response:

Question75: What do SAP S/4HANA embedded analytics and SAP HANA Live have in common?
There are 3 correct answers to this question.
Response:

Question76: Your newly created analytic privilege does NOT want to build. What must you do?
Please choose the correct answer.
Response:

Question77: You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
There are 2 correct answers to this question.
Response:

Question78: Which join type makes use of date ranges?
Please choose the correct answer.
Response:

Question79: How can the system database administrator disable tenant database functionalities?
Please choose the correct answer.
Response:

Question80: What are typical characteristics of SAP HANA data replication?
There are 2 correct answers to this question.
Response:

Question81: Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question.
Response:

Question82: What information can you find in the SAP HANA Cockpit?
There are 2 correct answers to this question.
Response:

Question83: Which storage is required if you implement multistore tables for SAP HANA?
Please choose the correct answer.
Response:

Question84: What is the preferred way to create a procedure?
Please choose the correct answer.
Response:

Question85: Which of the following benefits characterize the use of a design time filter?
There are 3 correct answers to this question.
Response:

Question86: You have a view with two tables joined by a left outer join. If you redesign the view and accidently swap the two tables around, what should you do to the join?
Please choose the correct answer.
Response:

Question87: What can be used to return multiple result sets?
Please choose the correct answer.
Response: